Open the pivot table settings pane
You can configure the pivot table by using the pane that contains the following tabs:
•Constructor: Use this tab to select the structure (layout) of the pivot table.
•Options: This tab contains the pivot table parameters.
The pivot table settings pane opens automatically when you select any cell in the pivot table and collapses automatically when you select any cell outside the pivot table.
|
The pivot table settings pane is unavailable if the sheet with the pivot table is protected from changes and the Work with pivot tables option is disabled in the Allowed actions list. |
You can also open and collapse the pivot table settings pane manually.
|
If you close the pane manually, the pane will not open or close automatically until the next time you open the application. |
To collapse the pane manually, do one of the following:
•At the top of the pane, click 
.
•On the Sidebar, click 
Pivot table.
To open the pane manually, do the following:
1.Select the entire range or one/several cells from the range of the pivot table.
2.Open the pane in one of the following ways:
•On the Home tab, in the Pivot table group, click 
Pivot table settings.
•On the Sidebar, click Pivot table.
•When working in macOS, select the Data > Pivot table settings command from the command menu.
•Right-click to open the context menu and run the Pivot table settings command.
